CREATE TABLE [dbo].[Counter]
(
[COUNTER_NAME] [char] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Counter_COUNTER_NAME] DEFAULT (''),
[LAST_VALUE] [int] NOT NULL CONSTRAINT [DF_Counter_LAST_VALUE] DEFAULT ((0)),
[LAST_UPDATED] [datetime] NULL,
[UPDATED_BY] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Counter_UPDATED_BY] DEFAULT (''),
[PAGEPAD1] [char] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Counter_PAGEPAD1] DEFAULT (''),
[PAGEPAD2] [char] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Counter_PAGEPAD2] DEFAULT (''),
[PAGEPAD3] [char] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Counter_PAGEPAD3] DEFAULT (''),
[PAGEPAD4] [char] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Counter_PAGEPAD4] DEFAULT (''),
[HAS_CHECKSUM] [bit] NOT NULL CONSTRAINT [DF_Counter_HAS_CHECKSUM] DEFAULT ((0)),
[TIME_STAMP] [timestamp] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[Counter] ADD CONSTRAINT [PK_Counter] PRIMARY KEY CLUSTERED ([COUNTER_NAME]) ON [PRIMARY]
GO
GRANT REFERENCES ON  [dbo].[Counter] TO [IMIS]
GRANT SELECT ON  [dbo].[Counter] TO [IMIS]
GRANT INSERT ON  [dbo].[Counter] TO [IMIS]
GRANT DELETE ON  [dbo].[Counter] TO [IMIS]
GRANT UPDATE ON  [dbo].[Counter] TO [IMIS]
GO